I have seen every movie that has been mentioned and I would rank them like this:
1. Rudy
2. Best of Times
3. Remember the Titans
4. The Waterboy
5. The Longest Yard(2005)
6. North Dallas Forty
7. The Longest Yard(1973)
8. All The Right Moves
9. Friday Night Lights
10. The Junction Boys

-I thought Everybody's All American had a pretty good story as well.

-Another movie with football as a subplot was The Last Boyscout.

-Quarterback Princess is also pretty decent with Helen Hunt playing the starring role in a true story about a girl who tries out for the football team and is forced into the starting lineup at QB after injuries to the 1st and 2nd stringer. Not a bad flick.

-Anyone who loves the oldie classics should try "Moochie plays Pop Warner" which stars the little kid from "Old Yeller." I was surprised in this one with how much attention they paid to the X's and O's...you will see alot of the single wing offense and I saw them run the old statue of liberty a time or two. This one is from the early 50's and truly is a pretty much undiscovered classic.